SPOOL /home/oracle/labs/labs/ORDER_ITEMS_XML.txt

SELECT DBMS_METADATA.GET_XML
      ('TABLE', 'ORDER_ITEMS', 'OE')
FROM   dual; 

SPOOL OFF
